Miami- Pandas Profiling Report

Dataset info

Number of variables	38
Number of observations	154117
Missing cells	849987 (14.5%)
Duplicate rows	0 (0.0%)
Total size in memory	43.7 MiB
Average record size in memory	297.0 B

Variables types

Numeric	8
Categorical	25
Boolean	2
Date	0
URL	0
Text (Unique)	1
Rejected	2
Unsupported	0

Warnings

`AdditionSQFT` is highly skewed (γ1 = 27.99978385)	Skewed
`AdditionSQFT` has 140060 (90.9%) zeros	Zeros
`AdditionSQFT` has 3197 (2.1%) missing values	Missing
`ApplicationNumber` has a high cardinality: 77932 distinct values	Warning
`BuildingFinalLastInspDate` has a high cardinality: 31514 distinct values	Warning
`BuildingFinalLastInspDate` has 119957 (77.8%) missing values	Missing
`BuildingFinalLastInspResult` has 154116 (> 99.9%) missing values	Missing
`Certificatecode` has 140926 (91.4%) missing values	Missing
`Certificatedate` has a high cardinality: 10522 distinct values	Warning
`Certificatedate` has 140926 (91.4%) missing values	Missing
`CompanyAddress` has a high cardinality: 9695 distinct values	Warning
`CompanyAddress` has 6227 (4.0%) missing values	Missing
`CompanyCity` has a high cardinality: 849 distinct values	Warning
`CompanyCity` has 6227 (4.0%) missing values	Missing
`CompanyName` has a high cardinality: 9754 distinct values	Warning
`CompanyName` has 6227 (4.0%) missing values	Missing
`CompanyZip` has 6227 (4.0%) missing values	Missing
`DaysInCity` has a high cardinality: 32136 distinct values	Warning
`DaysInCity` has 5031 (3.3%) missing values	Missing
`DaysInCityNumeric` has 81058 (52.6%) zeros	Zeros
`DaysInCityNumeric` has 5031 (3.3%) missing values	Missing
`DeliveryAddress` has a high cardinality: 41535 distinct values	Warning
`FirstSubmissionDate` has a high cardinality: 94606 distinct values	Warning
`FirstSubmissionDate` has 4981 (3.2%) missing values	Missing
`IssuedDate` has a high cardinality: 127696 distinct values	Warning
`Location_1` has a high cardinality: 31970 distinct values	Warning
`Miami21Zone` has a high cardinality: 157 distinct values	Warning
`NewAdditionCost` is highly skewed (γ1 = 43.34014033)	Skewed
`NewAdditionCost` has 57046 (37.0%) zeros	Zeros
`NewAdditionCost` has 90440 (58.7%) missing values	Missing
`PlanAcceptedDate` has a high cardinality: 98179 distinct values	Warning
`PlanCreatedDate` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`PlanCreatedDate` has a high cardinality: 102994 distinct values	Warning
`ProcessNumber` has a high cardinality: 109652 distinct values	Warning
`RemodelingCost` is highly skewed (γ1 = 50.87572019)	Skewed
`RemodelingCost` has 53872 (35.0%) zeros	Zeros
`RemodelingCost` has 70585 (45.8%) missing values	Missing
`RemSQFT` is highly skewed (γ1 = 62.82331835)	Skewed
`RemSQFT` has 122019 (79.2%) zeros	Zeros
`RemSQFT` has 3197 (2.1%) missing values	Missing
`RequiredCertificate` has 79079 (51.3%) missing values	Missing
`Statusdate` only contains datetime values, but is categorical. Consider applying `pd.to_datetime()`	Type
`Statusdate` has a high cardinality: 118181 distinct values	Warning
`TotalCost` is highly correlated with `NewAdditionCost` (ρ = 0.9322690698)	Rejected
`TotalDaysInPlanReview` has a high cardinality: 74681 distinct values	Warning
`TotalDaysInPlanReviewNumeric` has 37133 (24.1%) zeros	Zeros
`TotalSQFT` is highly correlated with `AdditionSQFT` (ρ = 0.9908311729)	Rejected
`WorkItems` has a high cardinality: 14730 distinct values	Warning

AdditionSQFT
Numeric

Distinct count	1558
Unique (%)	1.0%
Missing (%)	2.1%
Missing (n)	3197
Infinite (%)	0.0%
Infinite (n)	0

Mean	2754.821342
Minimum	0
Maximum	2450323
Zeros (%)	90.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	775
Maximum	2450323
Range	2450323
Interquartile range	0

Descriptive statistics

Standard deviation	44500.89122
Coef of variation	16.15382113
Kurtosis	1010.10109
Mean	2754.821342
MAD	5258.444164
Skewness	27.99978385
Sum	415757637
Variance	1980329319
Memory size	1.2 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	140060	90.9%
200	163	0.1%
4000	150	0.1%
300	124	0.1%
5000	111	0.1%
100	92	0.1%
1500	85	0.1%
2500	84	0.1%
500	82	0.1%
400	82	0.1%
Other values (1547)	9887	6.4%
(Missing)	3197	2.1%

Minimum 5 values

Value	Count	Frequency (%)
0	140060	90.9%
1	77	< 0.1%
2	8	< 0.1%
4	1	< 0.1%
10	8	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
2450323	6	< 0.1%
1904889	6	< 0.1%
1844181	6	< 0.1%
1788667	6	< 0.1%
1575474	6	< 0.1%

ApplicationNumber
Categorical

Distinct count	77932
Unique (%)	50.6%
Missing (%)	0.0%
Missing (n)	0

BD15007674	117
BD14014244	116
BD13024837	114
Other values (77929)	153770

Toggle details

Common values
Composition

Value	Count	Frequency (%)
BD15007674	117	0.1%
BD14014244	116	0.1%
BD13024837	114	0.1%
BD14013442	112	0.1%
BD12010756	103	0.1%
BD14014407	98	0.1%
BD14011309	98	0.1%
BD13021838	95	0.1%
BD14009787	94	0.1%
BD15002212	91	0.1%
Other values (77922)	153079	99.3%

Max length	10
Mean length	10
Min length	10
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

BuildingFinalLastInspDate
Categorical

Distinct count	31514
Unique (%)	20.4%
Missing (%)	77.8%
Missing (n)	119957

07/02/2015 09:00:00 AM	7
09/28/2018 09:59:00 AM	6
03/10/2016 03:18:00 PM	6
Other values (31510)	34141
(Missing)	119957

Toggle details

Common values
Composition

Value	Count	Frequency (%)
07/02/2015 09:00:00 AM	7	< 0.1%
09/28/2018 09:59:00 AM	6	< 0.1%
03/10/2016 03:18:00 PM	6	< 0.1%
06/04/2018 02:59:00 PM	6	< 0.1%
05/23/2014 12:26:00 PM	6	< 0.1%
01/26/2017 08:23:00 AM	6	< 0.1%
06/01/2015 10:26:00 AM	5	< 0.1%
04/22/2015 02:34:00 PM	5	< 0.1%
06/04/2018 03:00:00 PM	5	< 0.1%
06/26/2013 03:32:00 PM	5	< 0.1%
Other values (31503)	34103	22.1%
(Missing)	119957	77.8%

Max length	22
Mean length	7.211345925
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

BuildingFinalLastInspResult
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	> 99.9%
Missing (n)	154116

OK	1
(Missing)	154116

Toggle details

Common values
Composition

Value	Count	Frequency (%)
OK	1	< 0.1%
(Missing)	154116	> 99.9%

Max length	3
Mean length	2.999993511
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

BuildingPermitStatusDescription
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Final	133189
Active	11167
Revoked	5045
Other values (2)	4716

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Final	133189	86.4%
Active	11167	7.2%
Revoked	5045	3.3%
Expired	4372	2.8%
Hold	344	0.2%

Max length	7
Mean length	5.192431724
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

BuildingPermitStatusReasonDescription
Categorical

Distinct count	13
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

All Inspections are finalized.	133189
Permit is Active. Ready for Inspections.	11166
Revoked	5045
Other values (10)	4717

Toggle details

Common values
Composition

Value	Count	Frequency (%)
All Inspections are finalized.	133189	86.4%
Permit is Active. Ready for Inspections.	11166	7.2%
Revoked	5045	3.3%
Permit is Expired	4372	2.8%
Building Official	214	0.1%
Expired TCC/TCO	46	< 0.1%
Hold with Stop Work Order	29	< 0.1%
NSF Check	17	< 0.1%
Litigation	11	< 0.1%
Insufficient Fee Collection	11	< 0.1%
Other values (3)	17	< 0.1%

Max length	40
Mean length	29.57420012
Min length	7
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

Certificatecode
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	91.4%
Missing (n)	140926

CC	8087
C40	3191
CO	1754
Other values (2)	159
(Missing)	140926

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CC	8087	5.2%
C40	3191	2.1%
CO	1754	1.1%
TCC	103	0.1%
TCO	56	< 0.1%
(Missing)	140926	91.4%

Max length	3
Mean length	2.936145915
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

Certificatedate
Categorical

Distinct count	10522
Unique (%)	6.8%
Missing (%)	91.4%
Missing (n)	140926

08/24/2016 02:00:00 AM	76
08/29/2016 02:00:00 AM	63
11/08/2016 02:00:00 AM	54
Other values (10518)	12998
(Missing)	140926

Toggle details

Common values
Composition

Value	Count	Frequency (%)
08/24/2016 02:00:00 AM	76	< 0.1%
08/29/2016 02:00:00 AM	63	< 0.1%
11/08/2016 02:00:00 AM	54	< 0.1%
06/25/2017 02:00:00 AM	53	< 0.1%
08/31/2016 02:00:00 AM	51	< 0.1%
05/18/2018 02:00:00 AM	36	< 0.1%
09/17/2016 02:00:00 AM	27	< 0.1%
06/20/2018 02:01:00 AM	26	< 0.1%
05/17/2018 02:01:00 AM	26	< 0.1%
09/20/2016 02:00:00 AM	23	< 0.1%
Other values (10511)	12756	8.3%
(Missing)	140926	91.4%

Max length	22
Mean length	4.62622553
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

CompanyAddress
Categorical

Distinct count	9695
Unique (%)	6.3%
Missing (%)	4.0%
Missing (n)	6227

104 Crandon Blvd #308	955
2122 NW 7 AV	847
11600 DR ML KING JR ST. N.	739
Other values (9691)	145349
(Missing)	6227

Toggle details

Common values
Composition

Value	Count	Frequency (%)
104 Crandon Blvd #308	955	0.6%
2122 NW 7 AV	847	0.5%
11600 DR ML KING JR ST. N.	739	0.5%
8319 NW 43 rd Street	664	0.4%
10125 NW 116 Way	654	0.4%
2455 PACES FERRY ROAD BUILDING C-20	637	0.4%
14008 NW 82 AV	608	0.4%
7481 NW 66 ST	588	0.4%
7451 nw 63 st	549	0.4%
10785 MARKS WAY	526	0.3%
Other values (9684)	141123	91.6%
(Missing)	6227	4.0%

Max length	80
Mean length	16.8546429
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

CompanyCity
Categorical

Distinct count	849
Unique (%)	0.6%
Missing (%)	4.0%
Missing (n)	6227

MIAMI	48763
Miami	31383
HIALEAH	5709
Other values (845)	62035
(Missing)	6227

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MIAMI	48763	31.6%
Miami	31383	20.4%
HIALEAH	5709	3.7%
Hialeah	4601	3.0%
HOLLYWOOD	1837	1.2%
DORAL	1833	1.2%
POMPANO BEACH	1542	1.0%
Ft. Lauderdale	1340	0.9%
MIAMI LAKES	1295	0.8%
Hollywood	1249	0.8%
Other values (838)	48338	31.4%
(Missing)	6227	4.0%

Max length	21
Mean length	6.957110507
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

CompanyName
Categorical

Distinct count	9754
Unique (%)	6.3%
Missing (%)	4.0%
Missing (n)	6227

Mar B Plumbing Corp.	955
FRIENDLY JOHN INC	847
POWER DESIGN INC	739
Other values (9750)	145349
(Missing)	6227

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Mar B Plumbing Corp.	955	0.6%
FRIENDLY JOHN INC	847	0.5%
POWER DESIGN INC	739	0.5%
MARINI PLUMBING INC	664	0.4%
Fisk Electric Company	654	0.4%
Home Depot AtHome Services (the)	637	0.4%
TROPICAL FIRE & SECURITY SYSTEMS INC	597	0.4%
THYSSENKRUPP ELEVATOR CORP MIAMI	588	0.4%
United Site Services of Florida Inc.	549	0.4%
OTIS ELEVATOR COMPANY	526	0.3%
Other values (9743)	141134	91.6%
(Missing)	6227	4.0%

Max length	85
Mean length	25.47123289
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

CompanyZip
Numeric

Distinct count	830
Unique (%)	0.5%
Missing (%)	4.0%
Missing (n)	6227
Infinite (%)	0.0%
Infinite (n)	0

Mean	33154.69175
Minimum	0
Maximum	98466
Zeros (%)	0.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	33012
Q1	33073
Median	33155
Q3	33178
95-th percentile	33442
Maximum	98466
Range	98466
Interquartile range	105

Descriptive statistics

Standard deviation	3315.473555
Coef of variation	0.1000001321
Kurtosis	147.5797001
Mean	33154.69175
MAD	440.0561458
Skewness	2.846926246
Sum	4903247363
Variance	10992364.9
Memory size	1.2 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33166	6376	4.1%
33155	5703	3.7%
33186	4562	3.0%
33165	3995	2.6%
33142	3520	2.3%
33144	3245	2.1%
33016	3230	2.1%
33126	2923	1.9%
33012	2874	1.9%
33014	2655	1.7%
Other values (819)	108807	70.6%
(Missing)	6227	4.0%

Minimum 5 values

Value	Count	Frequency (%)
0	533	0.3%
1970	1	< 0.1%
2115	2	< 0.1%
2118	68	< 0.1%
3042	5	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
98466	2	< 0.1%
98106	1	< 0.1%
98045	1	< 0.1%
95438	2	< 0.1%
95008	1	< 0.1%

DaysInCity
Categorical

Distinct count	32136
Unique (%)	20.9%
Missing (%)	3.3%
Missing (n)	5031

0 Day(s) 0 Hour(s) 1 Minute(s)	2412
0 Day(s) 0 Hour(s) 2 Minute(s)	1385
0 Day(s) 0 Hour(s) 3 Minute(s)	1058
Other values (32132)	144231
(Missing)	5031

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0 Day(s) 0 Hour(s) 1 Minute(s)	2412	1.6%
0 Day(s) 0 Hour(s) 2 Minute(s)	1385	0.9%
0 Day(s) 0 Hour(s) 3 Minute(s)	1058	0.7%
0 Day(s) 0 Hour(s) 0 Minute(s)	1001	0.6%
0 Day(s) 0 Hour(s) 4 Minute(s)	933	0.6%
0 Day(s) 0 Hour(s) 5 Minute(s)	773	0.5%
0 Day(s) 0 Hour(s) 6 Minute(s)	721	0.5%
0 Day(s) 0 Hour(s) 7 Minute(s)	685	0.4%
0 Day(s) 0 Hour(s) 10 Minute(s)	599	0.4%
0 Day(s) 0 Hour(s) 8 Minute(s)	598	0.4%
Other values (32125)	138921	90.1%
(Missing)	5031	3.3%

Max length	35
Mean length	30.52480907
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

DaysInCityNumeric
Numeric

Distinct count	947
Unique (%)	0.6%
Missing (%)	3.3%
Missing (n)	5031
Infinite (%)	0.0%
Infinite (n)	0

Mean	34.37273118
Minimum	0
Maximum	3148
Zeros (%)	52.6%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	18
95-th percentile	183
Maximum	3148
Range	3148
Interquartile range	18

Descriptive statistics

Standard deviation	110.1943011
Coef of variation	3.205863989
Kurtosis	103.7017723
Mean	34.37273118
MAD	49.95426548
Skewness	7.955846467
Sum	5124493
Variance	12142.78399
Memory size	1.2 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	81058	52.6%
1	4866	3.2%
3	2512	1.6%
2	2470	1.6%
6	2220	1.4%
5	2146	1.4%
4	2048	1.3%
7	2013	1.3%
8	1684	1.1%
13	1504	1.0%
Other values (936)	46565	30.2%
(Missing)	5031	3.3%

Minimum 5 values

Value	Count	Frequency (%)
0	81058	52.6%
1	4866	3.2%
2	2470	1.6%
3	2512	1.6%
4	2048	1.3%

Maximum 5 values

Value	Count	Frequency (%)
3148	7	< 0.1%
2843	1	< 0.1%
2406	1	< 0.1%
2359	2	< 0.1%
2282	3	< 0.1%

DeliveryAddress
Categorical

Distinct count	41535
Unique (%)	27.0%
Missing (%)	0.0%
Missing (n)	0

701 S MIAMI AV	745
1611 NW 12 AV	719
180 SE 32 RD	413
Other values (41532)	152240

Toggle details

Common values
Composition

Value	Count	Frequency (%)
701 S MIAMI AV	745	0.5%
1611 NW 12 AV	719	0.5%
180 SE 32 RD	413	0.3%
1400 NW 12 AV	333	0.2%
1475 NW 12 AV	304	0.2%
301 BISCAYNE BLVD	278	0.2%
460 NE 28 ST	273	0.2%
200 S BISCAYNE BLVD	262	0.2%
600 BRICKELL AV	254	0.2%
3663 S MIAMI AV	200	0.1%
Other values (41525)	150336	97.5%

Max length	37
Mean length	15.23539908
Min length	9
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

FirstSubmissionDate
Categorical

Distinct count	94606
Unique (%)	61.4%
Missing (%)	3.2%
Missing (n)	4981

03/17/2014 10:21:00 AM	12
03/03/2016 10:00:00 AM	12
10/29/2015 09:54:00 AM	11
Other values (94602)	149101
(Missing)	4981

Toggle details

Common values
Composition

Value	Count	Frequency (%)
03/17/2014 10:21:00 AM	12	< 0.1%
03/03/2016 10:00:00 AM	12	< 0.1%
10/29/2015 09:54:00 AM	11	< 0.1%
05/02/2013 07:53:00 AM	11	< 0.1%
11/13/2014 09:21:00 AM	10	< 0.1%
08/19/2013 09:55:00 AM	10	< 0.1%
06/03/2013 08:36:00 AM	10	< 0.1%
03/08/2017 10:01:00 AM	10	< 0.1%
07/24/2017 09:31:00 AM	10	< 0.1%
04/19/2017 07:58:00 AM	10	< 0.1%
Other values (94595)	149030	96.7%
(Missing)	4981	3.2%

Max length	22
Mean length	21.38592757
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

FolioNumber
Numeric

Distinct count	37721
Unique (%)	24.5%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.332130916e+11
Minimum	1.01e+11
Maximum	1.47170009e+11
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.01e+11
5-th percentile	1.020006012e+11
Q1	1.312507700e+11
Median	1.32310681e+11
Q3	1.412100115e+11
95-th percentile	1.413908429e+11
Maximum	1.47170009e+11
Range	4.617000897e+10
Interquartile range	9959241410

Descriptive statistics

Standard deviation	1.168528199e+10
Coef of variation	0.08771872075
Kurtosis	2.670836963
Mean	1.332130916e+11
MAD	7867428721
Skewness	-1.892854327
Sum	2.053040205e+16
Variance	1.365458151e+20
Memory size	1.2 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[1.01000000e+11 1.01000000e+11 1.01000001e+11 1.01000001e+11 1.01000001e+11 ... 1.42170000e+11 1.42170000e+11 1.42175000e+11 1.44690005e+11 1.47170009e+11], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1.021006011e+11	1238	0.8%
1.3135003e+11	811	0.5%
1.011403014e+11	715	0.5%
1.021003013e+11	588	0.4%
1.4138034e+11	559	0.4%
1.021003010e+11	555	0.4%
1.020503021e+11	520	0.3%
1.01120001e+11	501	0.3%
1.011403011e+11	501	0.3%
1.4139035e+11	490	0.3%
Other values (37711)	147639	95.8%

Minimum 5 values

Value	Count	Frequency (%)
1.01e+11	1	< 0.1%
1.01e+11	1	< 0.1%
1.010000001e+11	2	< 0.1%
1.010000003e+11	7	< 0.1%
1.010000005e+11	278	0.2%

Maximum 5 values

Value	Count	Frequency (%)
1.47170009e+11	413	0.3%
1.4221e+11	142	0.1%
1.4218e+11	1	< 0.1%
1.4218e+11	1	< 0.1%
1.421700001e+11	117	0.1%

IsPermitFinal
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

YES	133189
NO	20928

Toggle details

Value	Count	Frequency (%)
YES	133189	86.4%
NO	20928	13.6%

IsPrivateProvider
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	140717
True	13400

Toggle details

Value	Count	Frequency (%)
False	140717	91.3%
True	13400	8.7%

IssuedDate
Categorical

Distinct count	127696
Unique (%)	82.9%
Missing (%)	< 0.1%
Missing (n)	52

08/24/2016 02:00:00 AM	76
08/29/2016 02:00:00 AM	63
11/08/2016 02:00:00 AM	54
Other values (127692)	153872

Toggle details

Common values
Composition

Value	Count	Frequency (%)
08/24/2016 02:00:00 AM	76	< 0.1%
08/29/2016 02:00:00 AM	63	< 0.1%
11/08/2016 02:00:00 AM	54	< 0.1%
06/25/2017 02:00:00 AM	53	< 0.1%
08/31/2016 02:00:00 AM	51	< 0.1%
06/23/2017 03:41:00 PM	42	< 0.1%
05/18/2018 02:00:00 AM	36	< 0.1%
11/08/2017 04:47:00 PM	29	< 0.1%
09/17/2016 02:00:00 AM	27	< 0.1%
06/20/2018 02:01:00 AM	26	< 0.1%
Other values (127685)	153608	99.7%
(Missing)	52	< 0.1%

Max length	22
Mean length	21.99358929
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

Location_1
Categorical

Distinct count	31970
Unique (%)	20.7%
Missing (%)	0.0%
Missing (n)	0

(25.7672237928512, -80.1932309447959)	684
(25.7679434530999, -80.1971213733675)	626
(25.7906094667165, -80.2148913125127)	602
Other values (31967)	152205

Toggle details

Common values
Composition

Value	Count	Frequency (%)
(25.7672237928512, -80.1932309447959)	684	0.4%
(25.7679434530999, -80.1971213733675)	626	0.4%
(25.7906094667165, -80.2148913125127)	602	0.4%
(25.8049678684154, -80.1861028578785)	596	0.4%
(25.7606043802673, -80.1900149057218)	562	0.4%
(25.7611274810868, -80.1935450099428)	417	0.3%
(25.8035287900299, -80.1872679878723)	406	0.3%
(25.772151807327, -80.1874290228756)	390	0.3%
(25.7831148526855, -80.1897565441726)	376	0.2%
(25.7640481548699, -80.1920327865787)	358	0.2%
Other values (31960)	149100	96.7%

Max length	37
Mean length	35.39688029
Min length	22
Contains chars	False
Contains digits	True
Contains spaces	True
Contains non-words	True

Miami21Zone
Categorical

Distinct count	157
Unique (%)	0.1%
Missing (%)	0.1%
Missing (n)	184

T3-R	30287
T3-O	14606
T6-8-O	13056
Other values (153)	95984

Toggle details

Common values
Composition

Value	Count	Frequency (%)
T3-R	30287	19.7%
T3-O	14606	9.5%
T6-8-O	13056	8.5%
T5-O	10138	6.6%
T6-80-O	9052	5.9%
T6-48A-O	7883	5.1%
T6-48B-O	6051	3.9%
T6-12-O	5534	3.6%
T3-L	5306	3.4%
T6-36A-L	4178	2.7%
Other values (146)	47842	31.0%

Max length	21
Mean length	5.595891433
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

NewAdditionCost
Numeric

Distinct count	2210
Unique (%)	1.4%
Missing (%)	58.7%
Missing (n)	90440
Infinite (%)	0.0%
Infinite (n)	0

Mean	158696.5371
Minimum	0
Maximum	333507475
Zeros (%)	37.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	25000
Maximum	333507475
Range	333507475
Interquartile range	0

Descriptive statistics

Standard deviation	3809388.072
Coef of variation	24.00422934
Kurtosis	2427.503259
Mean	158696.5371
MAD	305723.7545
Skewness	43.34014033
Sum	1.010531939e+10
Variance	1.451143748e+13
Memory size	1.2 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	57046	37.0%
2000	209	0.1%
1000	194	0.1%
20000	188	0.1%
5000	156	0.1%
15000	151	0.1%
25000	149	0.1%
10000	142	0.1%
3000	115	0.1%
8000	106	0.1%
Other values (2199)	5221	3.4%
(Missing)	90440	58.7%

Minimum 5 values

Value	Count	Frequency (%)
0	57046	37.0%
1	1	< 0.1%
100	3	< 0.1%
125	3	< 0.1%
175	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
333507475	1	< 0.1%
261450644	1	< 0.1%
255000000	1	< 0.1%
201954131	1	< 0.1%
191782000	1	< 0.1%

PermitNumber
Categorical, Unique

First 5 values
BD12000007001B001
BD12000017001B001
BD12000017001E001
BD12000017001P001
BD12000025001B001

Last 5 values
BD19005622001B001
BD19005624001B001
BD19005624001P001
BD19005625001B001
BD19005625001P001

Toggle details

First 5 values

Value	Count	Frequency (%)
BD12000007001B001	1	< 0.1%
BD12000017001B001	1	< 0.1%
BD12000017001E001	1	< 0.1%
BD12000017001P001	1	< 0.1%
BD12000025001B001	1	< 0.1%

Last 5 values

Value	Count	Frequency (%)
BD19005625001P001	1	< 0.1%
BD19005625001B001	1	< 0.1%
BD19005624001P001	1	< 0.1%
BD19005624001B001	1	< 0.1%
BD19005622001B001	1	< 0.1%

PlanAcceptedDate
Categorical

Distinct count	98179
Unique (%)	63.7%
Missing (%)	< 0.1%
Missing (n)	9

06/26/2015 03:46:00 PM	13
10/29/2015 09:54:00 AM	12
09/27/2013 03:51:00 PM	12
Other values (98175)	154071

Toggle details

Common values
Composition

Value	Count	Frequency (%)
06/26/2015 03:46:00 PM	13	< 0.1%
10/29/2015 09:54:00 AM	12	< 0.1%
09/27/2013 03:51:00 PM	12	< 0.1%
03/03/2016 10:00:00 AM	12	< 0.1%
07/20/2016 08:47:00 AM	11	< 0.1%
06/03/2013 08:36:00 AM	10	< 0.1%
01/26/2016 08:26:00 AM	10	< 0.1%
04/03/2017 08:19:00 AM	10	< 0.1%
06/29/2015 02:54:00 PM	10	< 0.1%
09/16/2016 10:04:00 AM	10	< 0.1%
Other values (98168)	153998	99.9%

Max length	22
Mean length	21.99889045
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

PlanCreatedDate
Categorical

Distinct count	102994
Unique (%)	66.8%
Missing (%)	0.0%
Missing (n)	0

02/22/2016 10:47:00 AM	13
06/29/2015 11:45:00 AM	11
12/09/2016 09:08:00 AM	10
Other values (102991)	154083

Toggle details

Common values
Composition

Value	Count	Frequency (%)
02/22/2016 10:47:00 AM	13	< 0.1%
06/29/2015 11:45:00 AM	11	< 0.1%
12/09/2016 09:08:00 AM	10	< 0.1%
09/08/2014 01:46:00 PM	10	< 0.1%
10/07/2014 09:08:00 AM	10	< 0.1%
08/01/2013 08:37:00 AM	9	< 0.1%
03/17/2017 11:45:00 AM	9	< 0.1%
01/23/2017 12:02:00 PM	9	< 0.1%
04/17/2018 10:10:00 AM	9	< 0.1%
08/21/2013 02:16:00 PM	9	< 0.1%
Other values (102984)	154018	99.9%

Max length	22
Mean length	22
Min length	22
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

ProcessNumber
Categorical

Distinct count	109652
Unique (%)	71.1%
Missing (%)	0.0%
Missing (n)	0

BD15014334001	8
BD15008622001	8
BD16012001001	8
Other values (109649)	154093

Toggle details

Common values
Composition

Value	Count	Frequency (%)
BD15014334001	8	< 0.1%
BD15008622001	8	< 0.1%
BD16012001001	8	< 0.1%
BD13017714001	8	< 0.1%
BD16017362001	7	< 0.1%
BD16002172001	7	< 0.1%
BD13015665001	7	< 0.1%
BD16001129001	7	< 0.1%
BD14008038001	7	< 0.1%
BD18001797001	7	< 0.1%
Other values (109642)	154043	> 99.9%

Max length	13
Mean length	13
Min length	13
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

PropertyType
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Commercial	101019
Residential	53098

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Commercial	101019	65.5%
Residential	53098	34.5%

Max length	11
Mean length	10.34453045
Min length	10
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

RemodelingCost
Numeric

Distinct count	7042
Unique (%)	4.6%
Missing (%)	45.8%
Missing (n)	70585
Infinite (%)	0.0%
Infinite (n)	0

Mean	28028.59274
Minimum	0
Maximum	34000000
Zeros (%)	35.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	5000
95-th percentile	75000
Maximum	34000000
Range	34000000
Interquartile range	5000

Descriptive statistics

Standard deviation	327601.0738
Coef of variation	11.68810282
Kurtosis	3755.260307
Mean	28028.59274
MAD	46238.05309
Skewness	50.87572019
Sum	2341284409
Variance	1.073224635e+11
Memory size	1.2 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	53872	35.0%
1000	1234	0.8%
10000	924	0.6%
2000	785	0.5%
5000	768	0.5%
15000	710	0.5%
6000	553	0.4%
8000	531	0.3%
20000	495	0.3%
3000	493	0.3%
Other values (7031)	23167	15.0%
(Missing)	70585	45.8%

Minimum 5 values

Value	Count	Frequency (%)
0	53872	35.0%
1	4	< 0.1%
45	8	< 0.1%
50	1	< 0.1%
63	9	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
34000000	1	< 0.1%
29227440	1	< 0.1%
28859360	1	< 0.1%
20681401	1	< 0.1%
17977000	1	< 0.1%

RemSQFT
Numeric

Distinct count	2684
Unique (%)	1.7%
Missing (%)	2.1%
Missing (n)	3197
Infinite (%)	0.0%
Infinite (n)	0

Mean	604.4008746
Minimum	0
Maximum	671966
Zeros (%)	79.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	2350
Maximum	671966
Range	671966
Interquartile range	0

Descriptive statistics

Standard deviation	6064.000888
Coef of variation	10.03307762
Kurtosis	5723.204074
Mean	604.4008746
MAD	1023.345642
Skewness	62.82331835
Sum	91216180
Variance	36772106.77
Memory size	1.2 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	122019	79.2%
1000	807	0.5%
100	790	0.5%
200	745	0.5%
500	722	0.5%
300	567	0.4%
1200	500	0.3%
800	493	0.3%
2000	474	0.3%
1500	471	0.3%
Other values (2673)	23332	15.1%
(Missing)	3197	2.1%

Minimum 5 values

Value	Count	Frequency (%)
0	122019	79.2%
1	167	0.1%
2	14	< 0.1%
3	2	< 0.1%
4	16	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
671966	4	< 0.1%
540798	2	< 0.1%
435600	4	< 0.1%
234759	4	< 0.1%
200000	7	< 0.1%

RequiredCertificate
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	51.3%
Missing (n)	79079

CC	44243
CO	30795
(Missing)	79079

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CC	44243	28.7%
CO	30795	20.0%
(Missing)	79079	51.3%

Max length	3
Mean length	2.51311017
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

ScopeofWork
Categorical

Distinct count	20
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

REMODELING/REPAIRS	67983
NEW CONSTRUCTION	28168
BUILDING ROOFING	9585
Other values (17)	48381

Toggle details

Common values
Composition

Value	Count	Frequency (%)
REMODELING/REPAIRS	67983	44.1%
NEW CONSTRUCTION	28168	18.3%
BUILDING ROOFING	9585	6.2%
ELECTRICAL	8038	5.2%
DEMOLITION	7018	4.6%
ADDITION AND REMODELING	5927	3.8%
PLUMBING	5301	3.4%
SIGN	5203	3.4%
MECHANICAL	4873	3.2%
40 YEAR AND OLDER RECERTIFICATION	3197	2.1%
Other values (10)	8824	5.7%

Max length	33
Mean length	15.69126702
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

Statusdate
Categorical

Distinct count	118181
Unique (%)	76.7%
Missing (%)	0.0%
Missing (n)	0

02/12/2016 12:10:00 AM	172
08/24/2016 02:00:00 AM	76
09/05/2019 12:10:00 AM	67
Other values (118178)	153802

Toggle details

Common values
Composition

Value	Count	Frequency (%)
02/12/2016 12:10:00 AM	172	0.1%
08/24/2016 02:00:00 AM	76	< 0.1%
09/05/2019 12:10:00 AM	67	< 0.1%
08/29/2016 02:00:00 AM	63	< 0.1%
11/08/2016 02:00:00 AM	54	< 0.1%
06/25/2017 02:00:00 AM	53	< 0.1%
08/31/2016 02:00:00 AM	51	< 0.1%
09/14/2018 12:10:00 AM	43	< 0.1%
09/24/2019 12:10:00 AM	42	< 0.1%
09/23/2019 12:10:00 AM	38	< 0.1%
Other values (118171)	153458	99.6%

Max length	22
Mean length	22
Min length	22
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

TotalCost
Highly correlated

This variable is highly correlated with NewAdditionCost and should be ignored for analysis

Correlation	0.9322690698

TotalDaysInPlanReview
Categorical

Distinct count	74681
Unique (%)	48.5%
Missing (%)	< 0.1%
Missing (n)	61

0 Day(s) 0 Hour(s) 19 Minute(s)	270
0 Day(s) 0 Hour(s) 23 Minute(s)	267
0 Day(s) 0 Hour(s) 18 Minute(s)	267
Other values (74677)	153252

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0 Day(s) 0 Hour(s) 19 Minute(s)	270	0.2%
0 Day(s) 0 Hour(s) 23 Minute(s)	267	0.2%
0 Day(s) 0 Hour(s) 18 Minute(s)	267	0.2%
0 Day(s) 0 Hour(s) 20 Minute(s)	257	0.2%
0 Day(s) 0 Hour(s) 14 Minute(s)	251	0.2%
0 Day(s) 0 Hour(s) 37 Minute(s)	249	0.2%
0 Day(s) 0 Hour(s) 13 Minute(s)	247	0.2%
0 Day(s) 0 Hour(s) 30 Minute(s)	245	0.2%
0 Day(s) 0 Hour(s) 25 Minute(s)	245	0.2%
0 Day(s) 0 Hour(s) 15 Minute(s)	244	0.2%
Other values (74670)	151514	98.3%

Max length	35
Mean length	31.91105459
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

TotalDaysInPlanReviewNumeric
Numeric

Distinct count	1526
Unique (%)	1.0%
Missing (%)	< 0.1%
Missing (n)	61
Infinite (%)	0.0%
Infinite (n)	0

Mean	86.82916602
Minimum	0
Maximum	2531
Zeros (%)	24.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
Median	16
Q3	85
95-th percentile	424
Maximum	2531
Range	2531
Interquartile range	84

Descriptive statistics

Standard deviation	179.1941576
Coef of variation	2.06375537
Kurtosis	23.89640406
Mean	86.82916602
MAD	105.9271764
Skewness	4.127417511
Sum	13376554
Variance	32110.54613
Memory size	1.2 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37133	24.1%
1	6546	4.2%
2	3634	2.4%
5	3141	2.0%
6	3137	2.0%
7	3087	2.0%
3	3019	2.0%
4	2878	1.9%
14	2039	1.3%
8	1983	1.3%
Other values (1515)	87459	56.7%

Minimum 5 values

Value	Count	Frequency (%)
0	37133	24.1%
1	6546	4.2%
2	3634	2.4%
3	3019	2.0%
4	2878	1.9%

Maximum 5 values

Value	Count	Frequency (%)
2531	1	< 0.1%
2479	1	< 0.1%
2461	1	< 0.1%
2298	1	< 0.1%
2294	1	< 0.1%

TotalSQFT
Highly correlated

This variable is highly correlated with AdditionSQFT and should be ignored for analysis

Correlation	0.9908311729

WorkItems
Categorical

Distinct count	14730
Unique (%)	9.6%
Missing (%)	< 0.1%
Missing (n)	20

WINDOWS / DOORS / SKYLIGHT	4915
WOOD/LAMINATE/TILE	4284
REPLACE SAME LOCATION CENTRAL AC / HEATING SYSTEM	3896
Other values (14726)	141002

Toggle details

Common values
Composition

Value	Count	Frequency (%)
WINDOWS / DOORS / SKYLIGHT	4915	3.2%
WOOD/LAMINATE/TILE	4284	2.8%
REPLACE SAME LOCATION CENTRAL AC / HEATING SYSTEM	3896	2.5%
TEMPORARY FOR TESTING	3481	2.3%
FLAT ROOF	3467	2.2%
ELECTRICAL FOR FIRE ALARM	3370	2.2%
40 YEAR AND OLDER RECERTIFICATION	3197	2.1%
SERVICE REPAIR	3011	2.0%
EXISTING FIRE ALARM SYSTEM	2814	1.8%
SHINGLE ROOF	2813	1.8%
Other values (14719)	118849	77.1%

Max length	1478
Mean length	58.76763757
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

First rows

	AdditionSQFT	ApplicationNumber	BuildingFinalLastInspDate	BuildingFinalLastInspResult	BuildingPermitStatusDescription	BuildingPermitStatusReasonDescription	Certificatecode	Certificatedate	CompanyAddress	CompanyCity	CompanyName	CompanyZip	DaysInCity	DaysInCityNumeric	DeliveryAddress	FirstSubmissionDate	FolioNumber	IsPermitFinal	IsPrivateProvider	IssuedDate	Location_1	Miami21Zone	NewAdditionCost	PermitNumber	PlanAcceptedDate	PlanCreatedDate	ProcessNumber	PropertyType	RemodelingCost	RemSQFT	RequiredCertificate	ScopeofWork	Statusdate	TotalCost	TotalDaysInPlanReview	TotalDaysInPlanReviewNumeric	TotalSQFT	WorkItems
0	0.0	BD13022970	NaN	NaN	Final	All Inspections are finalized.	NaN	NaN	17225 S. Dixie Hwy	Miami	Isaacs Roofing	33157.0	0 Day(s) 4 Hour(s) 35 Minute(s)	0.0	159 NW 9 ST	10/05/2015 10:19:00 AM	101020501060	YES	True	10/26/2015 10:45:00 AM	(25.7827783915511, -80.1976130743953)	T6-24A-O	0.0	BD13022970014BR001	10/05/2015 10:19:00 AM	10/02/2015 12:52:00 PM	BD13022970014	Commercial	0.0	0.0	CO	NEW CONSTRUCTION	05/09/2016 10:44:00 AM	77000.0	21 Day(s) 0 Hour(s) 26 Minute(s)	21.0	0.0	METAL ROOF\|FLAT ROOF
1	780.0	BD13011542	06/29/2018 09:56:00 AM	NaN	Final	All Inspections are finalized.	CO	06/29/2018 09:56:00 AM	9800 SW 92 AV	MIAMI	AMCON GROUP INC	33176.0	178 Day(s) 14 Hour(s) 42 Minute(s)	178.0	3380 CRYSTAL CT	01/09/2013 02:58:00 PM	141150200160	YES	False	08/19/2013 11:22:00 AM	(25.7392170589991, -80.2239576056458)	T3-R	65000.0	BD13011542001B001	01/09/2013 02:57:00 PM	01/08/2013 11:19:00 AM	BD13011542001	Residential	15000.0	100.0	CO	ADDITION AND REMODELING	06/29/2018 09:56:00 AM	80000.0	221 Day(s) 20 Hour(s) 25 Minute(s)	221.0	880.0	SINGLE FAMILY RESIDENCE
2	0.0	BD13015901	NaN	NaN	Final	All Inspections are finalized.	NaN	NaN	10400 W .SR 84 BAY 112	DAVIE	CAILIS MECHANICAL CORP.	33324.0	0 Day(s) 0 Hour(s) 13 Minute(s)	0.0	1300 BRICKELL BAY DR	03/05/2014 11:36:00 AM	141391250001	YES	True	03/11/2014 09:15:00 AM	(25.7605625176232, -80.1900200492368)	T6-48A-O	NaN	BD13015901027MA001	03/05/2014 11:35:00 AM	02/26/2014 11:30:00 AM	BD13015901027	Commercial	NaN	0.0	CO	NEW CONSTRUCTION	09/19/2014 12:06:00 PM	1000.0	5 Day(s) 21 Hour(s) 40 Minute(s)	5.0	0.0	VENTING SYSTEM
3	0.0	BD15008841	NaN	NaN	Final	All Inspections are finalized.	NaN	NaN	11565 SW 7 ST	MIAMI	ESPIRITU SANTO DEVELOPMENT & CONSTRUCTION GROU...	33174.0	0 Day(s) 0 Hour(s) 55 Minute(s)	0.0	3517 CRYSTAL VIEW CT	06/26/2015 09:43:00 AM	141150250040	YES	False	06/26/2015 11:56:00 AM	(25.7374142240009, -80.2246739487278)	T3-R	NaN	BD15008841001BR001	06/26/2015 09:43:00 AM	06/25/2015 09:19:00 PM	BD15008841001	Residential	NaN	0.0	NaN	BUILDING ROOFING	07/14/2015 09:44:00 AM	19500.0	0 Day(s) 2 Hour(s) 13 Minute(s)	0.0	0.0	FLAT ROOF\|METAL ROOF
4	0.0	BD14002550	NaN	NaN	Final	All Inspections are finalized.	NaN	NaN	1461 NW 23 ST	Miami	T & S Roofing Systems Inc	33142.0	0 Day(s) 0 Hour(s) 30 Minute(s)	0.0	4880 NW 5 ST	03/07/2014 08:19:00 AM	141060780070	YES	False	03/07/2014 10:00:00 AM	(25.7770086304017, -80.2757351816447)	T3-O	NaN	BD14002550001BR001	03/07/2014 08:19:00 AM	03/07/2014 08:07:00 AM	BD14002550001	Residential	NaN	0.0	NaN	BUILDING ROOFING	04/24/2014 03:37:00 PM	12000.0	0 Day(s) 1 Hour(s) 41 Minute(s)	0.0	0.0	METAL ROOF
5	0.0	BD14010209	09/06/2016 04:04:00 PM	NaN	Final	All Inspections are finalized.	CC	09/06/2016 04:04:00 PM	1616-102 CAPE CORAL PKWY	CAPE CORAL	REYES INC	33914.0	142 Day(s) 14 Hour(s) 1 Minute(s)	142.0	1909 SW 27 AV	09/10/2014 11:07:00 AM	141100230110	YES	False	02/20/2015 09:59:00 AM	(25.7537150298413, -80.238230053775)	T6-8-O	0.0	BD14010209001B001	09/10/2014 11:07:00 AM	09/10/2014 09:53:00 AM	BD14010209001	Commercial	50000.0	800.0	CC	REMODELING/REPAIRS	09/06/2016 04:04:00 PM	50000.0	162 Day(s) 22 Hour(s) 52 Minute(s)	162.0	800.0	MEDICAL OR DENTAL OFFICE
6	0.0	BD16008841	NaN	NaN	Final	All Inspections are finalized.	NaN	NaN	301 FLAGLER DR	MIAMI	DOUGLAS ORR PLUMBING INC	33012.0	1 Day(s) 0 Hour(s) 53 Minute(s)	1.0	2470 NW 38 ST	06/22/2016 11:20:00 AM	131220380020	YES	False	06/23/2016 01:41:00 PM	(25.8109512528316, -80.2374171063099)	D1	NaN	BD16008841001P001	06/22/2016 11:19:00 AM	06/22/2016 10:36:00 AM	BD16008841001	Commercial	NaN	0.0	NaN	PLUMBING	07/06/2016 09:38:00 AM	8900.0	1 Day(s) 2 Hour(s) 22 Minute(s)	1.0	0.0	STORM SEWER
7	0.0	BD13015160	10/30/2014 09:50:00 AM	NaN	Final	All Inspections are finalized.	CC	10/31/2014 03:06:00 PM	4710 NW 37 Avenue	Miami	Toledo Doors Inc. dba Toledo Iron Works	33142.0	0 Day(s) 9 Hour(s) 19 Minute(s)	0.0	1925 BRICKELL AV # 5DPH	04/08/2013 10:01:00 AM	141390314370	YES	False	05/21/2013 10:22:00 AM	(25.7537938222174, -80.1982958458641)	T6-24-R	0.0	BD13015160001B001	04/08/2013 10:00:00 AM	04/08/2013 09:48:00 AM	BD13015160001	Commercial	32000.0	0.0	NaN	REMODELING/REPAIRS	10/30/2014 09:50:00 AM	32000.0	43 Day(s) 0 Hour(s) 22 Minute(s)	43.0	0.0	INTERIOR RAILINGS:METAL/GLASS/WOOD/CONCRETE\|EX...
8	0.0	BD16004566	07/05/2016 09:05:00 AM	NaN	Final	All Inspections are finalized.	NaN	NaN	17661 NW 82 CT	MIAMI	BY HIS GRACE CONSTRUCTION SERVICES INC	33015.0	0 Day(s) 1 Hour(s) 28 Minute(s)	0.0	65 NW 26 ST	04/25/2016 08:47:00 AM	131250290150	YES	False	05/12/2016 03:55:00 PM	(25.801601167324, -80.1963579287021)	T5-L	NaN	BD16004566001B001	04/25/2016 08:47:00 AM	04/07/2016 04:00:00 PM	BD16004566001	Residential	NaN	0.0	NaN	DEMOLITION	07/05/2016 09:05:00 AM	8399.0	17 Day(s) 7 Hour(s) 8 Minute(s)	17.0	0.0	DEMOLITION - TOTAL
9	0.0	BD16009303	09/26/2016 10:42:00 AM	NaN	Final	All Inspections are finalized.	CC	11/16/2016 07:38:00 AM	18630 NE 18 Ave #234	Miami	Great Walls of America Inc	33179.0	0 Day(s) 3 Hour(s) 36 Minute(s)	0.0	555 NE 15 ST # 11-E	07/01/2016 09:15:00 AM	132310521680	YES	False	07/07/2016 12:01:00 PM	(25.7897947573702, -80.1856839336501)	T6-36B-O	NaN	BD16009303001B001	07/01/2016 09:15:00 AM	07/01/2016 08:36:00 AM	BD16009303001	Commercial	14500.0	0.0	CC	REMODELING/REPAIRS	09/26/2016 10:42:00 AM	14500.0	6 Day(s) 2 Hour(s) 46 Minute(s)	6.0	0.0	KITCHEN REMODELING/BATHROOM REMODELING/LAUNDRY...

Last rows

	AdditionSQFT	ApplicationNumber	BuildingFinalLastInspDate	BuildingFinalLastInspResult	BuildingPermitStatusDescription	BuildingPermitStatusReasonDescription	Certificatecode	Certificatedate	CompanyAddress	CompanyCity	CompanyName	CompanyZip	DaysInCity	DaysInCityNumeric	DeliveryAddress	FirstSubmissionDate	FolioNumber	IsPermitFinal	IsPrivateProvider	IssuedDate	Location_1	Miami21Zone	NewAdditionCost	PermitNumber	PlanAcceptedDate	PlanCreatedDate	ProcessNumber	PropertyType	RemodelingCost	RemSQFT	RequiredCertificate	ScopeofWork	Statusdate	TotalCost	TotalDaysInPlanReview	TotalDaysInPlanReviewNumeric	TotalSQFT	WorkItems
154107	0.0	BD17017975	NaN	NaN	Active	Permit is Active. Ready for Inspections.	NaN	NaN	5101 COLLINS AV	MIAMI BEACH	REBUILD MIAMI LLC	33140.0	0 Day(s) 6 Hour(s) 34 Minute(s)	0.0	1129 NW 28 ST	12/11/2017 10:30:00 AM	131260361740	NO	False	06/04/2018 03:37:00 PM	(25.8025244658363, -80.2139244460857)	T3-O	NaN	BD17017975001B001	12/11/2017 10:30:00 AM	12/11/2017 09:42:00 AM	BD17017975001	Residential	7000.0	0.0	NaN	REMODELING/REPAIRS	07/26/2019 10:43:00 AM	7000.0	175 Day(s) 5 Hour(s) 7 Minute(s)	175.0	0.0	CBS FENCE
154108	0.0	BD18011149	07/25/2019 09:20:00 AM	NaN	Final	All Inspections are finalized.	CC	07/26/2019 08:47:00 AM	31 SE 5 STREET # 2908	Miami	Rubio Construction Consultants	33131.0	75 Day(s) 11 Hour(s) 0 Minute(s)	75.0	200 SE 1 ST 601	08/24/2018 08:52:00 AM	101120002040	YES	True	01/07/2019 01:01:00 PM	(25.77332504, -80.18994634)	T6-80-O	NaN	BD18011149001B001	08/23/2018 08:50:00 AM	07/17/2018 09:09:00 AM	BD18011149001	Commercial	314650.0	3596.0	CC	REMODELING/REPAIRS	07/25/2019 09:20:00 AM	314650.0	137 Day(s) 4 Hour(s) 11 Minute(s)	137.0	3596.0	PROFESSIONAL OFFICE / BANK / FINANCIAL INSTITU...
154109	0.0	BD17001452	NaN	NaN	Active	Permit is Active. Ready for Inspections.	NaN	NaN	3715 NORTHSIDE PKWY NW BLDG 300 - SUITE 30327	ATLANTA	JUNEAU CONSTRUCTION	33324.0	9 Day(s) 8 Hour(s) 37 Minute(s)	9.0	3015 GRAND AV	06/20/2018 09:43:00 AM	141211260010	NO	True	07/31/2018 03:53:00 PM	(25.7282207815248, -80.2419336841946)	T5-O	NaN	BD17001452003B001	06/20/2018 09:43:00 AM	06/12/2018 03:22:00 PM	BD17001452003	Commercial	NaN	0.0	CC	REMODELING/REPAIRS	07/26/2019 09:49:00 AM	17354.0	41 Day(s) 6 Hour(s) 10 Minute(s)	41.0	0.0	REGULAR EXTERIOR:DOORS
154110	0.0	BD17016666	NaN	NaN	Active	Permit is Active. Ready for Inspections.	NaN	NaN	2200 D DIXIE HWY	Hollywood	Bengoa Construction Inc.	33139.0	213 Day(s) 0 Hour(s) 15 Minute(s)	213.0	1925 BRICKELL AV	11/14/2017 09:46:00 AM	141390310001	NO	False	09/24/2018 11:12:00 AM	(25.7537938222174, -80.1982958458641)	T6-24A-R	NaN	BD17016666001B001	11/14/2017 09:45:00 AM	11/14/2017 09:05:00 AM	BD17016666001	Commercial	2300000.0	0.0	NaN	REMODELING/REPAIRS	09/24/2018 11:12:00 AM	2300000.0	314 Day(s) 1 Hour(s) 27 Minute(s)	314.0	0.0	WOOD OR METAL DECK/CONCRETE SLAB\|EXTERIOR RAIL...
154111	0.0	BD17012936	NaN	NaN	Active	Permit is Active. Ready for Inspections.	NaN	NaN	8181 NW 36 ST #31	MIAMI	FLORIDA LEMARK CORP	33166.0	1258 Day(s) 21 Hour(s) 32 Minute(s)	1258.0	401 BISCAYNE BLVD	09/25/2017 11:07:00 AM	101000000522	NO	False	07/26/2019 03:59:00 PM	(25.7789472940884, -80.1867494973167)	T6-8-O	NaN	BD17012936001B001	09/25/2017 11:06:00 AM	08/28/2017 12:08:00 PM	BD17012936001	Commercial	NaN	0.0	NaN	PHASED PERMIT	07/26/2019 03:59:00 PM	100.0	669 Day(s) 4 Hour(s) 53 Minute(s)	669.0	0.0	PHASE CLASS II: FOUNDATION ONLY
154112	0.0	BD19005137	NaN	NaN	Final	All Inspections are finalized.	NaN	NaN	2530 SW 153RD PASS	MIAMI	ELECTRICFIRE CORP	33185.0	NaN	NaN	717 NE 27 ST	NaN	132300190180	YES	False	04/22/2019 01:50:00 PM	(25.80298868, -80.18573575)	T6-36A-L	0.0	BD19005137001F001	03/27/2019 10:08:00 AM	03/21/2019 09:17:00 AM	BD19005137001	Commercial	0.0	0.0	NaN	FIRE	07/26/2019 09:19:00 AM	8000.0	26 Day(s) 3 Hour(s) 42 Minute(s)	26.0	0.0	EXISTING FIRE ALARM SYSTEM
154113	0.0	BD13011378	NaN	NaN	Active	Permit is Active. Ready for Inspections.	NaN	NaN	350 BUSINESS PARKWAY SUITE 104	ROYAL PALM BEACH	AG SERVICES MAINTENANCE & REPAIR INC	33411.0	56 Day(s) 3 Hour(s) 25 Minute(s)	56.0	2153 SW 22 ST 601	01/03/2013 10:25:00 AM	141100530030	NO	False	03/28/2013 10:21:00 AM	(25.7507822844358, -80.2291934525465)	T5-O	0.0	BD13011378001MA001	01/03/2013 10:25:00 AM	01/03/2013 10:15:00 AM	BD13011378001	Commercial	0.0	1200.0	CC	REMODELING/REPAIRS	07/26/2019 11:14:00 AM	10000.0	83 Day(s) 23 Hour(s) 56 Minute(s)	83.0	1200.0	NEW CENTRAL AC / HEATING SYSTEM\|SHEET METAL WORK
154114	0.0	BD17018324	NaN	NaN	Final	All Inspections are finalized.	NaN	NaN	8900 sw 126 terr	Miami	Alpero General Contractor Inc.	33127.0	10 Day(s) 0 Hour(s) 36 Minute(s)	10.0	2953 SHIPPING AV	02/01/2019 11:09:00 AM	141210170070	YES	False	02/19/2019 12:38:00 PM	(25.7337208815229, -80.2407565067646)	T3-O	NaN	BD17018324004BR001	02/01/2019 11:06:00 AM	01/18/2019 08:07:00 PM	BD17018324004	Residential	NaN	0.0	CO	NEW CONSTRUCTION	07/26/2019 11:21:00 AM	15000.0	18 Day(s) 1 Hour(s) 32 Minute(s)	18.0	0.0	FLAT ROOF
154115	0.0	BD19003668	NaN	NaN	Active	Permit is Active. Ready for Inspections.	NaN	NaN	1600 nw 28th ave	Miami	CPS Electric Inc.	33125.0	NaN	NaN	3131 NE 7 AV # 3201	NaN	132300950270	NO	False	07/26/2019 12:53:00 PM	(25.80729208, -80.18590346)	T6-36A-L	0.0	BD19003668001E001	03/11/2019 06:37:00 AM	03/01/2019 09:37:00 AM	BD19003668001	Commercial	0.0	2327.0	NaN	REMODELING/REPAIRS	07/26/2019 12:53:00 PM	3000.0	137 Day(s) 6 Hour(s) 16 Minute(s)	137.0	2327.0	FIXTURE HEADS\|ROUGH WIRING OUTLETS
154116	301.0	BD16010527	NaN	NaN	Active	Permit is Active. Ready for Inspections.	NaN	NaN	15700 NE 2nd Avenue	Miami	Regosa Engineering Services	33162.0	350 Day(s) 12 Hour(s) 20 Minute(s)	350.0	5601 NE 5 AV	09/09/2016 09:46:00 AM	132180370350	NO	False	07/26/2019 03:02:00 PM	(25.8279324875411, -80.1846579277803)	T3-R	0.0	BD16010527001P001	09/09/2016 08:37:00 AM	07/27/2016 12:18:00 PM	BD16010527001	Residential	0.0	200.0	CO	ADDITION AND REMODELING	07/26/2019 03:02:00 PM	25000.0	1050 Day(s) 6 Hour(s) 25 Minute(s)	1050.0	501.0	ROUGHING FIXTURE: BATHTUB\|SETTING FIXTURE: BAT...

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows